package com.dao;

import com.entity.Types;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @author liuronghua
 * @version 1.0
 * @data 2020-09-2020/9/22 9:30
 * @desc
 */
public interface TypeDao {

    @Select("select * from types order by num")
    public List<Types> selectList();

    @Select("select * from types")
    List<Types>findAll(@Param("id")int id,@Param("name")String name,@Param("num")int num);
    @Select("select * from types where id=#{id}")
    public Types select(int id);


}
